<?php
/**
 * @Author: Marte
 * @Date:   2017-08-14 18:55:44
 * @Last Modified by:   Marte
 * @Last Modified time: 2017-08-21 22:09:52
 */
$_sql1='select * from bookshelf where username="'.$_username.'" order by id desc';
$_result1=$_mysql->query($_sql1);

?>
 <div class="select1">
                        <ul>
                    <?php
                        while($_assoc1=$_result1->fetch_assoc())
                        {
                            $_sspp='select bookid from books where bookname="'.$_assoc1['bookname'].'"';
                            $_result0=$_mysql->query($_sspp);
                            $_assox=$_result0->fetch_assoc();
                    ?>
                            <li>
                                <i><a href="bookinfo.php?id=<?php echo $_assox['bookid']?>" title=""><img src="<?php echo $_assoc1['picicon']?>" alt=""></a></i>
                                <span><?php echo $_assoc1['bookname']?></span>

                            </li>
                    <?php
                        }

                    ?>
                        </ul>
                        <div class="clear">

                        </div>
                    </div>

